﻿using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace WMS_DATABASE_MYSQL.MappingClass.CategoryClass
{
    //部门类别表
    [SugarTable("wms_deptsecgrp_table")]
    [SugarIndex("deptsecgrpidx", nameof(wms_deptsecgrp_table.dept), OrderByType.Asc,nameof(wms_deptsecgrp_table.section), OrderByType.Asc, nameof(wms_deptsecgrp_table.group), OrderByType.Asc)]
    public class wms_deptsecgrp_table
    {
        [SugarColumn(IsIdentity = true, IsPrimaryKey = true)]
        public int key { get; set; }
        [SugarColumn(ColumnDataType = "tinyint(1) unsigned")]
        public byte dept { get; set; }//类别号，表示类别的类别
        [SugarColumn(ColumnDataType = "Nvarchar(64)")]
        public string? deptdesc { get; set; } = "";
        [SugarColumn(ColumnDataType = "tinyint(1) unsigned")]
        public byte section { get; set; }//类别号，表示类别的类别
        [SugarColumn(ColumnDataType = "Nvarchar(64)")]
        public string? secdesc { get; set; } = "";
        [SugarColumn(ColumnDataType = "tinyint(1) unsigned")]
        public byte group { get; set; }//类别号，表示类别的类别
        [SugarColumn(ColumnDataType = "Nvarchar(64)")]
        public string? groupdesc { get; set; } = "";
    }
}
